Gestor 48jNAsZKQ6jifu3w6Xglp9VU9Y7VSuIdy12xzGQlY0/HePtMT0/TyMND/czqAHdnw9bjL9lnegntE+Gt4oT1RvHe469VV/Nle3qlpXrs6D+DcNkJ2VRBvEVw+ex0PWqLwsibbEs= Gestor config nome_fantasia,System.String cnpj_cpf,System.String logradouro,System.String numero,System.String bairro,System.String uf,System.String telefone,System.String razao_social,System.String cidade,System.String ie_rg,System.String imagem_logo,System.Byte[] 30 False config Gestor select c.razao_social, c.nome_fantasia, c.cnpj_cpf, c.logradouro, c.numero, c.bairro, c.uf, c.telefone, cidade.nome as cidade, c.ie_rg, c.imagem_logo from configuracao c left join cidade on cidade.id = c.cidade_id dados codigo,System.Int32 nome,System.String estoque,System.Decimal marca,System.String valor_compra,System.Decimal valor_venda,System.Decimal sigla,System.String quantidade_compra,System.Decimal total_compra,System.Decimal quantidade_venda,System.Decimal total_venda,System.Decimal valor_estoque,System.Decimal tipo_mercadoria,System.String 30 False dados Gestor select p.id as codigo, p.descricao as nome, p.marca, p.valor_compra, p.valor_venda, p.tipo_mercadoria,p.estoque, u.sigla as sigla, (select coalesce(sum(item.quantidade), 0) from mov_estoque_item item inner join mov_estoque mov on mov.id = item.movimentacao_estoque_id where mov.status = 'Fechado' and item.produto_id = p.id ) as quantidade_compra, (select coalesce(sum(item.valor_total), 0) from mov_estoque_item item inner join mov_estoque mov on mov.id = item.movimentacao_estoque_id where mov.status = 'Fechado' and item.produto_id = p.id ) as total_compra, (select coalesce(sum(item.quantidade), 0) from orcamento_item item inner join orcamento orc on orc.id = item.orcamento_id where orc.status = 'Faturado' and item.produto_id = p.id ) as quantidade_venda, (select coalesce(sum(item.valor_liquido), 0) from orcamento_item item inner join orcamento orc on orc.id = item.orcamento_id where orc.status = 'Faturado' and item.produto_id = p.id ) as total_venda, case when p.estoque > 0 then sum(p.valor_venda * p.estoque) else 0 end as valor_estoque from produto p left join unidade u on u.id = p.unidade_id left join (select un.sigla, pu.fator_conversao, pu.produto_id from produto_unidade pu inner join unidade un on un.id = pu.unidade_id) as un_sec ON un_sec.produto_id = p.id where p.inativo = 0 and p.tipo_mercadoria <> '09 - SERVICOS' and p.estoque > 0 and case when '{grupo_id}' <> '' and '{grupo_id}' <> '0' then p.grupo_id in ({grupo_id}) else 1 = 1 end and case when '{subgrupo_id}' <> '' and '{subgrupo_id}' <> '0' then p.subgrupo_id in ({subgrupo_id}) else 1 = 1 end and case when '{produto_id}' <> '' and '{produto_id}' <> '0' then p.id in ({produto_id}) else 1 = 1 end group by p.id ,grupo_id,Grupo,Grupo_x0020_do_x0020_produto,System.String,_x0030_,False,False,False ,subgrupo_id,subgrupo_id,Subgrupo_x0020_de_x0020_produtos,System.String,_x0030_,False,False,False ,produto_id,produto_id,Código_x0020_do_x0020_produto,System.String,_x0030_,False,False,False ,tipo_unidade,tipo_unidade,Tipo_x0020_de_x0020_unidade_x0020_a_x0020_ser_x0020_utilizada,System.String,_x0031_,False,False,False ,descricao_filtros,descricao_filtros,System.String,,False,False ,codigo_relatorio,codigo_relatorio,System.String,,False,False EngineV2 None;Black;2;Solid;False;4;Black Transparent Transparent 0,26.9,19,0.8 Transparent 15.4,0.1,3.6,0.4 Arial,10 Right 0,0,0,0 Text3 {PageNofMThrough} Black Transparent 0,0.1,4.2,0.6 Arial,8 0,0,0,0 Text21 Kinyx Gestor - www.kinyx.com.br Black Expression PageFooterBand1 Transparent 0,0.4,19,3.6 GlassBrush,Gainsboro,True,0.2 0,2.2,19,0.8 Transparent 0.2,0.1,18.6,0.6 Tahoma,14.25,Bold,Point,False,0 90389c2d449a41bd9ad3828265a183af Center 0,0,0,0 Text1 INVENTÁRIO DE ESTOQUE Black Expression 80a81346cc9f4d53b794a0dcd3e69a5b Panel1 Transparent 2.2,0,13.6,0.6 Tahoma,9.75,Bold,Point,False,0 3d8e041e8fa14d408107f4d82a0be504 0,0,0,0 Text4 {config.razao_social} Black Expression Transparent 2.2,0.4,13.6,1.8 Tahoma,9,Regular,Point,False,0 ba465ff4be094ba1b7a1e140dca5afbe 0,0,0,0 Text14 CNPJ: {config.cnpj_cpf} - IE: {config.ie_rg} End.: {config.logradouro}, {config.numero} Bairro: {config.bairro} {config.cidade}/{config.uf} Black Expression Transparent 13.6,0.2,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 1f9e690879664329a8ee049b38366c58 Right 0,0,0,0 Text2 {Today.ToString("dd/MM/yyyy")} {Time.ToString("HH:mm")} Black Expression Transparent 15.8,0.6,3.2,0.6 Tahoma,8.25,Bold,Point,False,0 679f8e370e874eee8399094c5d3bc60c Right 0,0,0,0 Text20 Rel: {codigo_relatorio} Black Expression Transparent 0,0,2.2,2.2 config.imagem_logo ae8bc5f5a0c542b0a541565ed7771b22 imgLogo True Transparent 0,3,19,0.6 Tahoma,8.25,Bold,Point,False,0 cc8a05f040374ccb89ba4c151cbe8ba2 0,0,0,0 Text44 {descricao_filtros} Black Expression Center ReportTitleBand1 Transparent 0,4.8,19,1.4 Transparent 0,0.2,3.4,0.6 Arial,9.75,Bold,Point,False,0 0,0,0,0 Text30 Tipo de mercadoria: Black Expression Center Transparent 3.4,0.2,15.6,0.6 Arial,9.75,Bold,Point,False,0 0c91e098401a4ff28d868b229027b84e 0,0,0,0 Text31 {dados.tipo_mercadoria} Black Expression Center Transparent 0,0.8,1.8,0.6 Tahoma,8.25,Bold,Point,False,0 8d21e504f4c34a259bb5bd3ebe812ef1 0,0,0,0 Text5 Código Black Expression Center Transparent 1.4,0.8,5.4,0.6 Tahoma,8.25,Bold,Point,False,0 1b6698d245dc4281882e1960f95c769f 0,0,0,0 Text6 Nome do produto Black Expression Center Transparent 12.8,0.8,0.6,0.6 Tahoma,8.25,Bold,Point,False,0 6aa5f4c980424a969091ce71aa8350e9 0,0,0,0 Text7 UN Black Expression Center Transparent 7.4,0.8,1.6,0.6 False Tahoma,8.25,Bold,Point,False,0 1885cf49561e4aabb12f83214133b841 Right 0,0,0,0 Text10 Vl. compra Black Expression Center Transparent 15.8,0.8,1.6,0.6 Tahoma,8.25,Bold,Point,False,0 ee8f75f70dd148b288819f8abe43120d Right 0,0,0,0 Text11 Vl. Compra Black Expression Center Transparent 9,0.8,1.8,0.6 False Tahoma,8.25,Bold,Point,False,0 25b3e00199a9436da49eb6fa22d15ea8 Right 0,0,0,0 Text8 Qt. compra Black Expression Center Transparent 10.8,0.8,1.8,0.6 False Tahoma,8.25,Bold,Point,False,0 8e42cdd9db804ee6a5c3923a77ed3223 Right 0,0,0,0 Text24 Total compra Black ,,,,WordWrap=True,A=0 Expression Center Transparent 14.2,0.8,1.4,0.6 False Tahoma,8.25,Bold,Point,False,0 d76ab58b7d974f49b2b3a003a515e2a9 Right 0,0,0,0 Text26 Qt. venda Black Expression Center Transparent 14.6,0.8,1.8,0.6 False Tahoma,8.25,Bold,Point,False,0 530e0949f9284d7c89d8dc45d9fc0ba6 Right 0,0,0,0 Text22 Total venda Black Expression Center Transparent 17.4,0.8,1.6,0.6 Tahoma,8.25,Bold,Point,False,0 610b930b511a4d06a1f3866ee6b800ce Right 0,0,0,0 Text9 Estoque Black Expression Center 0,0.2,0,0 StartPointPrimitive1 fa5bcf3cd5d744a8994721b37d19158a 19,1.4,0,0 EndPointPrimitive1 fa5bcf3cd5d744a8994721b37d19158a {dados.tipo_mercadoria} GroupHeaderBand1 Transparent 0,7,19,0.4 Transparent 0,0,1.4,0.4 Tahoma,6.75,Regular,Point,False,0 0,0,0,0 Text12 {dados.codigo} Black 00000 Transparent 1.4,0,11.4,0.4 Tahoma,6.75,Regular,Point,False,0 0,0,0,0 Text13 {dados.nome} Black Transparent 9.2,0,1.6,0.4 False Tahoma,6.75,Regular,Point,False,0 Right 0,0,0,0 Text16 {dados.quantidade_compra} Black DataColumn Transparent 12.8,0,0.6,0.4 Tahoma,6.75,Regular,Point,False,0 0,0,0,0 Text15 {dados.sigla} Black Transparent 7.4,0,1.6,0.4 False Tahoma,6.75,Regular,Point,False,0 Right 0,0,0,0 Text18 {dados.valor_compra} Black , . 1 False Transparent 15.8,0,1.6,0.4 Tahoma,6.75,Regular,Point,False,0 Right 0,0,0,0 Text19 {dados.valor_compra} Black , . 1 False Expression Transparent 10.8,0,1.8,0.4 False Tahoma,6.75,Regular,Point,False,0 f038e31d4596488094b0c86c27ccf3d6 Right 0,0,0,0 Text25 {dados.total_compra} Black DataColumn Transparent 14.2,0,1.4,0.4 False Tahoma,6.75,Regular,Point,False,0 b412d2cb312f403c909c987a86b1ec7b Right 0,0,0,0 Text27 {dados.quantidade_venda} Black , . 1 False DataColumn Transparent 14.6,0,1.8,0.4 False Tahoma,6.75,Regular,Point,False,0 9a82211ef07a444498832d4505565647 Right 0,0,0,0 Text23 {dados.valor_compra} Black Expression Transparent 17.4,0,1.6,0.4 Tahoma,6.75,Regular,Point,False,0 Right 0,0,0,0 Text17 {dados.estoque} Black , . 1 False 0,0.4,19,0.0254 Black Black HorizontalLinePrimitive1 Black 0,0,0,0 StartPointPrimitive2 2567504c4f274f1a89132a1e4f6460ca 19,0.4,0,0 EndPointPrimitive2 2567504c4f274f1a89132a1e4f6460ca dados DataBand1 ASC codigo Transparent 0,8.2,19,2.6 Transparent 13.4,0,2.4,1.6 False Tahoma,8.25,Regular,Point,False,0 6628cbd893e3491181e4cc0f3ce50cc8 0,0,0,0 Text32 Qtde itens: Total compra: Total venda: Total em estoque: Black Expression Center Transparent 15.8,0,3.2,1.6 False Tahoma,8.25,Bold,Point,False,0 22bb5d4e44eb4c40bc59957b87dd311d Right 0,0,0,0 Text33 {Count(DataBand1)} {Format("{0:C2}", Sum(DataBand1,dados.total_compra))} {Format("{0:C2}", Sum(DataBand1,dados.total_venda))} {Format("{0:C2}", Sum(DataBand1,dados.valor_estoque))} Black Expression Center 0,0,0,0 StartPointPrimitive4 2c01ff857742478c8093814c1b68ad7d False GroupFooterBand1 Transparent 0,11.6,19,2 Transparent 13.4,0.4,2.4,0.8 Tahoma,8.25,Regular,Point,False,0 799a8c70a7894fcf937bff203934c3a7 0,0,0,0 Text28 Qtde itens: Black Expression Center Transparent 15.8,0.4,3.2,0.8 Tahoma,8.25,Bold,Point,False,0 663c3a3084384fe5b76a2651e72bd8f2 Right 0,0,0,0 Text29 {Count(DataBand1)} Black Expression Center Transparent 13.4,0,2.4,0.4 Tahoma,8.25,Bold,Point,False,0 90daa433fb51414bb018daeff04a83ec 0,0,0,0 Text34 TOTAIS Black Expression Center Transparent 15.8,1.2,3.2,0.8 Tahoma,8.25,Bold,Point,False,0 163a79fbff284074b5eb7470b5092719 Right 0,0,0,0 Text35 {Sum(dados.estoque * dados.valor_compra)} Black , . 1 Expression Center Transparent 13.4,1.2,2.4,0.8 Tahoma,8.25,Regular,Point,False,0 f613b18ff59240868065c37e80557b36 0,0,0,0 Text36 Total Inventário: Black Expression Center 19,-0.4,0,0 EndPointPrimitive4 2c01ff857742478c8093814c1b68ad7d 13.4,0.4,0,0 StartPointPrimitive5 3b5ea4b8b66e4aa69ad4439ddbd7c4ab 19,2,0,0 EndPointPrimitive5 3b5ea4b8b66e4aa69ad4439ddbd7c4ab ReportSummaryBand1 False 0,5,19,1.2 Black fa5bcf3cd5d744a8994721b37d19158a RectanglePrimitive1 False 0,7,19,0.4 Black 2567504c4f274f1a89132a1e4f6460ca RectanglePrimitive2 False 0,8.2,19,3 Black 2c01ff857742478c8093814c1b68ad7d False RectanglePrimitive4 False 13.4,12,5.6,1.6 Black 3b5ea4b8b66e4aa69ad4439ddbd7c4ab RectanglePrimitive5 16e140f4ea7b4950b32fdf7a12ea7df3 1,1,1,1 Page1 29.7 21 Arial,100 [50:0:0:0] System.Dll System.Drawing.Dll System.Windows.Forms.Dll System.Data.Dll System.Xml.Dll Stimulsoft.Controls.Dll Stimulsoft.Base.Dll Stimulsoft.Report.Dll Gestor.exe Gestor.exe Gestor.exe Gestor.exe Report 1/24/2019 2:51:11 PM 9/25/2015 9:37:43 PM C:\Users\Farias\Google Drive\Relatórios\INVENTARIO DE ESTOQUE.mrt fcf55ff70dd642638494040ab3c1e25f Report Centimeters 2015.1.0 CSharp